<?php
/* 
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

include("sqlconnect.php");
include("sqlgenerator.php");
$debug = false;

db_connect();

$query = get_ticketinfo_list();
if ($debug)
    echo 'Query: ' . $query;
$result = db_query($query);

if ($debug)
    echo 'Query Result: ' .$resut;

echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>";
echo "<tickets>";
while($row = mysql_fetch_array($result))
  {
    echo "<ticket>";
    echo "<rate>" . $row['ticket_rate'] . "</rate>";
    echo "<coupon_value>" . $row['coupon_value'] . "</coupon_value>";
    echo "</ticket>";
  }
echo "</tickets>";
?>
